SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 385183 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 385183 [ RunTime:0.002167s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (527464,88025,542265,665371,212843,329296,386621,442751,519143,158669,766890,408397,60334,993570,505325,6786,568213,263444,265397,347918,174003,2867,879448,375634,933806,378824,703981,590305,774364,794928,512792,861963,63636,1028617,706463,771998,881167,701496,814991,959146,696047,8691,928333,425635,442983,71051,209396,45293,369276,467892,234789,996456,57615,693039,716774,621828,489571,470050,1013545,268119) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 385183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 385183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]