SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504597 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504597 [ RunTime:0.001637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (780358,345276,360005,509107,141137,929330,1017502,377542,359356,533944,741211,84940,218268,246461,932300,328094,558639,787082,550797,959626,639975,140424,797616,139936,555192,697804,52421,6345,642980,717742,858355,375078,960471,652386,441255,649565,725660,547613,3564,740090,118895,389779,814643,956934,569924,627279,733387,29141,833510,891199,269601,1000915,33257,695801,696605,88212,364354,879039,858739,404640) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000948s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504597 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504597 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002512s ]