SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527916 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527916 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (504641,800831,688389,617284,965582,950550,957709,165531,553974,887563,524776,188622,207104,476591,970610,371180,259117,392410,182567,239509,920908,855733,812853,573378,727019,86685,1004826,148589,486037,1047388,622014,342116,354451,869675,610915,414897,1021115,594148,467655,108375,71265,589616,237507,931519,152561,363152,827519,882503,515384,943083,382552,1033017,341958,765429,612595,915538,270614,750254,478580,563151) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]