SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001460s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402160 LIMIT 1 [ RunTime:0.000508s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402160 [ RunTime:0.003638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (434930,420233,446079,90870,566909,920578,826852,582858,656265,571380,51632,644777,1041570,323509,10391,170201,915426,763724,929162,270715,835269,16642,1002917,535906,918123,556296,354587,466063,582337,624356,26944,844290,929893,617466,587480,638764,913711,587686,393010,198479,475151,409708,67185,334075,463899,172712,458099,285638,973296,230347,24628,356292,98210,892303,298823,785929,398066,471469,401046,120209) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]