SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401047 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401047 [ RunTime:0.002879s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (504998,872295,576429,250106,26247,651331,97271,839332,231906,792975,677471,894116,53797,998662,145934,155095,100703,31276,333317,711586,655116,652396,462271,683615,476511,767917,524426,245445,369546,570174,916208,787536,806094,746798,582214,643611,1046921,198934,1048649,165347,725549,32742,621745,563526,534964,464530,443875,486697,543190,831082,964933,994360,849794,430705,818796,1022805,618854,804827,772157,101113) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401047 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401047 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000692s ]