SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001789s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404063 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404063 [ RunTime:0.002192s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419914,240812,683501,998553,831353,763958,604162,352348,900075,664910,488918,893338,478634,170665,930759,1047479,307883,968130,509859,830423,566935,784608,248820,781949,850557,740667,275225,97758,127449,439540,272131,1003289,499632,98954,544325,558434,602001,197119,536530,239321,874971,919050,753562,1044644,567002,23147,96480,311500,404327,988172,640404,997841,660412,590981,172975,448183,42728,331629,772910,74904) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]