SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001735s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424551 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424551 [ RunTime:0.002461s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (301631,948012,622595,1031202,735956,214028,18611,855554,354368,765438,751707,45581,923729,508861,121935,21909,353127,1045583,927645,1014513,997982,187029,855760,366084,131875,335953,921977,841197,639570,1028628,1008572,700376,101254,217605,909946,931615,1013345,801961,206419,157105,562911,688458,395482,142955,776747,502472,315981,537485,105039,487542,864193,214290,298713,932252,344066,932235,357118,899079,484955,920180) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424551 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000682s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424551 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000987s ]