SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490110 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490110 [ RunTime:0.001959s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (351275,393812,86638,144263,247790,473719,749916,352789,280987,886891,925976,363680,1043589,859186,782409,664239,1033716,739423,278305,329696,325802,664782,863691,136967,956151,761866,172284,980052,709873,1016305,322605,959943,512025,718803,395188,972741,889942,22945,51303,954022,869566,229023,38771,1017506,954279,79705,279502,845769,849024,760660,469273,158011,779928,664753,1044222,468833,287681,820437,659368,106183) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]