SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003744s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407710 LIMIT 1 [ RunTime:0.003764s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407710 [ RunTime:0.004031s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (51576,800589,608483,414267,513012,412000,462667,962729,804613,901870,494968,851790,68373,767103,1014524,216288,471026,637244,569500,816635,989193,220832,595900,341277,600464,353847,931530,900128,588234,5714,290319,431804,809020,866278,735337,441351,660761,339750,525553,789036,172361,1030624,579694,713623,406243,395536,466521,524208,41925,933469,268224,895695,732876,304128,794971,880278,736872,706274,35464,213040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.006699s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000393s ]