SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001604s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 931006 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 931006 [ RunTime:0.004693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (698216,1042570,1005657,311442,637573,382035,1001620,657112,408780,960506,89865,899606,37679,983402,701379,803414,674068,786792,287286,350909,883766,290670,68359,144584,91854,496296,137871,971943,146112,611840,263031,825707,220275,1784,336452,500516,1013395,818422,857945,629094,1034768,402188,672448,700997,935688,842941,509965,342558,9562,521084,909958,561827,99566,184813,229652,965102,679732,598069,367641,967593) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001688s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 931006 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002704s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 931006 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]