SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535510 LIMIT 1 [ RunTime:0.000897s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535510 [ RunTime:0.001757s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (889448,32946,939147,248751,148498,909990,786244,1020712,249802,516783,116837,493155,612185,47558,580715,771015,806060,398654,253248,554051,358132,146917,629984,1009857,583447,42625,537706,283540,401203,64546,79209,865995,139738,840908,308338,189932,534484,211459,194759,696655,256669,770832,191428,312012,143788,106286,1006472,805737,439494,572697,29288,338811,14109,173611,169033,330736,267924,105332,574211,142924) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003833s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]