SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001609s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 841909 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 841909 [ RunTime:0.001690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (468475,197957,875490,529169,124228,400561,309714,623871,301667,397095,1043007,852894,1008570,726612,599628,24716,642986,1000878,502648,273890,74128,568921,562035,930493,944262,645764,584816,301314,546452,177762,156629,767442,584382,721735,12034,36768,422141,578220,362709,301344,988250,364775,1045437,559024,703644,493482,743594,496423,742593,454963,969548,586806,771932,678851,1047713,512985,879532,892906,187514,194232) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 841909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 841909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]