SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001401s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105175 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105175 [ RunTime:0.005174s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113769,511469,648421,39654,948368,90955,791795,101480,332737,863609,262993,644104,235915,290736,702508,241139,297836,38299,539509,303329,858758,241916,99118,122320,973388,7172,302321,479120,86699,8914,535612,755244,826387,1034528,792781,299070,56508,552320,347315,1023259,300765,185465,790238,394589,793725,522706,895262,917142,997761,539948,657555,97757,837361,924071,722955,234611,548777,67499,982689,787733) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105175 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105175 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000423s ]