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` = 107180 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107180 [ RunTime:0.001623s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (302724,670756,820159,15524,13186,783685,152869,429765,480155,99206,1019302,953306,917049,105210,403244,151797,847133,557099,397328,733140,127044,853025,879663,133472,366257,583439,127457,192797,553567,320482,167147,584923,929888,648458,925338,504567,550949,322089,842554,924218,269432,778471,295401,478149,816577,598959,385936,190517,813289,75595,695658,353077,152765,651848,363919,822406,744980,203739,168252,592286) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]