SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002449s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 989294 LIMIT 1 [ RunTime:0.000516s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 989294 [ RunTime:0.001966s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1021821,177182,383137,173794,368171,406738,959103,365753,324682,1000425,364960,594860,540644,956822,940459,974017,716236,765168,745460,11811,1032414,114033,674085,761922,670735,558148,1024105,243161,443812,254418,823118,949764,673271,979877,505200,822229,750402,106304,522911,240222,715968,1011178,859606,510782,527402,750493,895554,1022041,761164,515825,72800,58451,359547,770020,624963,749515,753092,427400,921932,996122) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008727s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 989294 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 989294 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]