SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200388 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200388 [ RunTime:0.001645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (743982,60758,261362,710842,49993,734347,1009809,517303,441522,1012718,488509,384237,609323,82034,254707,364764,917151,133544,531134,533393,300117,82499,528520,279709,391832,451464,529746,758950,676975,794042,350431,1011857,102223,896433,186693,319895,507628,166599,438657,681898,292061,504658,377443,90124,951561,321543,74434,438337,271451,933906,894027,1028089,330796,666062,463367,876023,397203,108995,616075,539486) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200388 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200388 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001298s ]