SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194514 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194514 [ RunTime:0.002980s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (192838,510689,770969,138071,244962,678531,873911,501590,302818,791025,193516,243103,509493,1006539,89028,61694,727152,547400,702968,420334,151739,742998,159031,545477,177662,396123,368119,796850,604644,1000710,384207,712416,199278,556268,139844,715300,869532,755908,668688,689633,169052,864311,591134,779450,918759,103922,228133,985799,790484,96670,581765,988990,944367,335639,281039,1009306,1032656,783113,763021,979316) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]