SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001528s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414264 LIMIT 1 [ RunTime:0.001875s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414264 [ RunTime:0.001657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (256195,1013194,61912,85973,1027340,926983,90522,5524,988081,401386,147968,734079,790202,1009248,650423,44458,697393,78294,594286,321627,178494,462066,680112,39029,139197,288422,652720,491129,169845,478410,329977,653402,83256,192717,295691,1025742,92613,135225,948580,638043,361477,299719,443086,232735,651439,1042645,538166,904275,167567,495399,976903,249513,401925,620970,176831,447590,555868,627671,93237,19687) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414264 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414264 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001228s ]