SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438014 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438014 [ RunTime:0.001414s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (77096,221438,907185,524341,516935,513837,214946,573045,552891,169330,772324,627299,623853,256796,623196,170548,757900,575281,724887,375607,425367,126721,541159,418190,131415,224537,332180,695502,455072,270213,651044,24844,123988,96863,84426,1040478,951160,559382,780318,932334,859079,709587,355630,772508,124422,884732,696525,540185,565826,276101,897841,580444,787785,846315,420843,402243,204111,341450,452048,743321) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]