SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001711s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485813 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485813 [ RunTime:0.003831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300690,943895,378863,16604,298535,642496,332584,1021725,80100,189971,761434,237144,248474,435251,137127,92951,453395,977946,568339,569010,387283,383903,241282,131205,249132,413698,926369,552061,875968,853038,1033256,738829,270296,287491,170817,181364,492960,357314,120365,267505,1012879,925296,489958,136681,517898,1022582,1017451,461363,331412,699830,573749,419797,985504,976823,625482,857530,55680,370117,285645,985587) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001683s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]