SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 380938 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 380938 [ RunTime:0.002567s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (313801,78585,282671,986022,109767,422475,23950,822229,720205,201539,701523,461887,440006,691570,25045,91415,690142,938014,342230,978017,441946,400027,1040220,518923,222615,94882,157462,269008,1004324,682026,167356,701754,671651,44884,969546,649178,535601,47199,679494,740270,254991,50553,108397,167314,604069,95694,287395,205024,572741,972832,578939,945514,639164,602759,731701,184997,356172,602427,488724,1005901) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002851s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 380938 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000544s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 380938 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]