SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001967s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 434028 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 434028 [ RunTime:0.002830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (397125,80190,402052,90392,1004384,225796,546960,221626,894517,869366,135756,556746,602914,869622,706308,1021472,185924,781860,591878,952501,229937,498122,784386,922824,77766,546626,746730,257288,125717,496136,836936,574861,253652,348827,676609,994573,246572,1029995,1040990,870558,969377,1006184,40517,600053,727441,749375,695795,560219,825981,5728,476015,920816,644409,1025211,442225,905138,347701,613836,884564,507921) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 434028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 434028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]