SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001569s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563318 LIMIT 1 [ RunTime:0.000622s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563318 [ RunTime:0.002276s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (912085,676436,1021607,342726,157534,19826,218027,266315,99444,610615,300657,546020,418527,841031,76101,456315,210068,1045009,238106,729351,10375,413535,299208,677925,792220,271704,546471,363021,16858,596476,631096,844741,158545,357058,142131,715490,492096,344915,231555,359004,75789,96118,738505,911989,34058,161438,682117,694427,911728,476049,327858,429958,448301,492048,956824,826631,337269,542708,758184,603478) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]