SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3460 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3460 [ RunTime:0.004966s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (779837,854569,281808,118713,619040,311010,87406,384651,613164,522984,989451,463170,957613,126289,273108,111423,491675,632894,194517,68376,270634,495631,1013266,957890,56791,1004420,262858,291989,240891,147208,1004448,647391,885173,904151,310646,773266,974712,493565,680017,576417,737728,629165,466537,664873,201062,175286,847689,900301,364690,665488,278334,826938,428173,164148,629659,15721,1009916,483518,603807,929449) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3460 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3460 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]