SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 324028 LIMIT 1 [ RunTime:0.001470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 324028 [ RunTime:0.003713s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1041807,630957,182674,909003,418640,422776,107794,66956,765939,123229,227622,123134,792261,934568,749914,1018711,215291,378995,381437,459402,290637,630772,773078,227383,99147,694993,722061,849293,230362,289107,971276,326679,949545,179756,339359,195061,1019497,134737,382271,193785,704470,228602,595426,30100,869164,630757,231596,227474,553564,910070,942576,634726,448126,834914,1001397,694117,100494,722517,381619,191445) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 324028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 324028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]