SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001398s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404258 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404258 [ RunTime:0.001902s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (190292,803886,266030,280971,23524,795539,852575,789804,325767,99821,240012,393574,285483,142060,971717,782743,329107,475145,39526,725453,507524,304843,644044,417214,1038116,271854,1022182,254243,205416,328560,87126,518348,81615,641926,605883,753649,407094,369830,910397,707244,133436,124293,207439,554240,897320,474406,501450,124915,364654,724295,320666,409590,253976,939989,502019,747778,689803,350556,636277,1004036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404258 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404258 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]