SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001369s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 551511 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 551511 [ RunTime:0.002403s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (994060,192534,467335,1044170,425980,943459,766211,676496,743510,338347,265323,334269,891607,925965,231659,383078,25314,138366,358858,617419,455370,831129,127136,954003,477454,799404,24645,1025957,808181,143508,489896,1851,17116,320346,615680,193830,121993,80442,954795,495313,102643,783017,23790,409186,641888,479930,508562,541887,571141,558686,312832,820865,785155,644217,778905,728384,35415,571047,570823,907428) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 551511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 551511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]