SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001489s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506001 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506001 [ RunTime:0.002000s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (826303,996219,437847,269460,584440,1014934,854868,386477,992351,766421,764914,28035,904392,667930,62997,308506,1015510,356084,889857,177702,1024555,471531,109734,832482,693337,348330,343407,355362,379021,18572,914189,755026,608983,348553,168624,622747,448464,434480,569902,253054,344936,1009979,618582,302814,602093,967246,771505,377687,271183,759290,884693,942741,736246,30220,731971,616661,240271,58552,759780,558204) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000757s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000747s ]