SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 811028 LIMIT 1 [ RunTime:0.000526s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 811028 [ RunTime:0.001952s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010486,779448,328118,610147,1043381,28591,157710,206156,187008,60743,790823,989033,791627,170595,430126,420912,689087,601657,943810,256038,77053,287199,688228,299143,921072,115769,97313,169409,373492,984298,986847,814290,80768,843310,686284,238838,512701,37098,954849,647042,893146,52525,1030525,389050,680453,814054,154436,937148,707856,296711,592318,595898,679243,63466,1010964,346288,330532,424509,811379,645449) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 811028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000783s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 811028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]