SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 393517 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 393517 [ RunTime:0.001533s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (7238,698672,875907,51303,363075,488523,980821,1028973,1023151,33627,221684,965702,763484,1004767,890120,240374,444517,631249,449145,161238,614195,656135,866467,527393,827453,386495,565075,683422,120109,615743,670925,560247,1030005,321071,127150,348698,476126,911796,731739,917749,592350,224697,66350,147428,145189,1033356,966928,998769,702155,701796,312480,257624,244630,134813,936085,95977,558462,550460,540004,123667) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001911s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 393517 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 393517 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]