SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014729 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014729 [ RunTime:0.001742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (237027,1028880,979569,852337,562505,34210,512756,582809,301679,894435,1047803,203592,627151,786523,726038,100448,308819,668686,993035,560277,514180,558206,115113,261030,879388,578775,1022066,601158,803528,36141,106861,923973,1014631,1001182,87521,40115,48809,886053,118801,278202,136165,988744,794767,463079,929291,258883,187891,937220,1025789,189150,722393,7823,1003355,63575,522181,500473,73669,628839,1004782,68444) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014729 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014729 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]