SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 135046 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 135046 [ RunTime:0.002078s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (283732,680079,278086,326136,842146,607380,1044283,188960,319232,933736,352974,450648,1027270,199149,820473,465340,368905,886881,749368,112159,654396,607110,703393,876535,1026902,264863,980996,917188,47433,240402,552697,190518,110229,588541,339720,907448,160333,695558,670379,331090,156129,1001575,513927,629269,103657,831722,190777,346663,917522,33272,55122,423498,169369,1003641,774679,712054,753057,1028891,840560,225289) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 135046 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001571s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 135046 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]