SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001465s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424067 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424067 [ RunTime:0.002462s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512671,826063,541891,800219,932596,155029,525722,231555,910313,919859,602965,989562,201140,1046747,131130,453980,158522,49711,961665,448205,556261,547465,559171,826189,382369,966055,977763,582341,874008,572845,104955,219228,915604,682390,880438,767445,118068,2878,271355,560605,71640,997841,794847,973908,1004036,275467,120180,408632,292548,732589,350534,730347,433638,128542,130714,241234,638065,61954,828089,518160) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424067 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001612s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424067 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002641s ]