SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413191 LIMIT 1 [ RunTime:0.000272s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413191 [ RunTime:0.002297s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (461142,438299,666008,225617,678912,653393,195095,230452,157432,686341,913736,730414,597815,430076,924487,839013,917793,940320,473543,741757,776456,927276,666278,527834,891194,12801,635401,735996,142262,653657,173108,840284,316026,929418,176498,730448,988004,219140,791472,471397,52102,603162,654281,56799,648453,552060,942700,432387,173340,283298,323998,329852,680709,802312,215707,866157,527831,306286,351837,157852) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]