SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424450 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424450 [ RunTime:0.002019s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (640958,616467,213238,858777,652467,330537,376784,970904,474380,935009,294909,602571,249627,902028,1016027,365657,154323,194663,148898,1000473,449215,65941,380718,105157,95801,181124,106347,613487,744047,568055,713503,387139,321381,1013850,349560,206887,596319,561819,342709,750343,400486,171818,73112,1009984,940083,1020615,708096,291147,1038582,207720,747929,689802,450582,352722,928049,708014,38428,635580,41347,411438) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424450 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424450 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]