SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508202 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508202 [ RunTime:0.002050s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (32475,541117,697352,853088,859784,716503,681155,1043081,916215,182524,358515,202220,93109,688535,409917,887729,622693,820827,925343,393387,191285,801237,108115,46328,760759,852992,468293,413481,761345,585570,356203,356345,329134,281761,484077,466338,189040,110410,565370,661344,511393,453789,255248,213430,467585,275160,733688,456375,413170,531045,434735,274180,65209,763970,701399,196691,75742,708427,81065,948651) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508202 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000652s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508202 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]