SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107383 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107383 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (935225,273882,96021,156384,50557,1035619,1013269,568489,1014877,893633,89912,477816,841995,721094,308590,389777,816221,691141,994724,253336,945161,609651,935367,937342,338188,822081,239150,674013,975873,411885,47951,899856,1018162,87086,654786,724312,544480,874341,724168,199861,942216,936176,78606,60111,602911,587341,1383,1036253,589505,415729,813957,309623,837887,806738,842979,839377,742991,6110,1024970,52282) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107383 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107383 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]