SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 251309 LIMIT 1 [ RunTime:0.000800s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 251309 [ RunTime:0.001861s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (396639,584164,831420,744049,31091,215373,528080,910143,459417,757666,125984,914780,573962,245595,548854,776693,728666,148273,751057,729114,277277,173839,725140,94544,798682,262335,444080,275260,326729,1004549,502435,730704,647729,664754,138609,341230,858435,653405,663167,840990,1025243,797445,372811,502087,481539,820395,883126,25029,742660,812374,243711,422289,375319,882394,49679,1005507,470077,41079,537718,420627) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 251309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 251309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]