SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803818 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803818 [ RunTime:0.001817s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (316343,64867,1037877,817011,458620,242679,832051,437623,267751,1033755,743564,223796,56618,872179,134747,885327,438385,256630,108003,567425,799411,723347,19613,751513,338875,553005,569320,222651,493931,365324,328194,803390,185297,1025990,53027,227280,964394,290677,425285,240491,287786,140859,115677,403152,794216,281113,169472,622825,896808,132201,769244,59577,450476,970249,859326,598265,634718,991589,12852,166828) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000425s ]