SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001689s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518638 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518638 [ RunTime:0.004137s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (523357,604545,898908,454995,491643,544592,394760,933129,274395,239354,189963,674959,486149,929644,699122,936895,275531,633906,824487,640394,172188,441150,694329,218419,708787,488319,127088,443675,887086,267448,956445,101425,469473,426746,2647,372803,856114,252549,1032131,200861,818318,513774,505013,127807,500990,769660,964478,174885,651894,389540,604143,394875,129069,889118,184581,392905,859536,398427,181687,200284) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518638 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518638 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002164s ]