SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022701 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022701 [ RunTime:0.001748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280130,105335,1004948,208735,512068,425027,867477,916197,65888,770677,771536,991168,133840,546303,539453,813680,756030,818079,527286,554025,176783,354351,645403,586378,411370,649826,797145,485433,839259,715458,608216,698625,138624,721275,883582,384001,74073,222391,292268,1038716,361114,775569,175331,441355,826141,975085,530799,512291,316083,457413,1026068,984214,96436,345683,956469,1044193,34594,875261,612839,30987) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002802s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000631s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001224s ]