SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035304 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035304 [ RunTime:0.002183s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (45567,338998,482242,826178,322305,969057,443418,37370,656693,254561,1020658,992430,49508,981320,776118,161946,320123,655772,386355,1013563,920925,524167,661966,375451,222401,890318,734567,491708,593278,140103,774748,1009205,485444,850849,893473,262994,807148,730605,882830,630628,417739,927676,902649,678113,88195,338128,283993,782930,719833,685156,586113,904458,521372,573352,973837,598803,420066,186345,108582,104593) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035304 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035304 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]