SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201872 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201872 [ RunTime:0.001771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (223190,232378,420531,440681,104432,423437,129942,321932,488143,225531,565405,372666,731285,824545,461102,164606,726189,768962,810453,376807,961150,825802,670270,24641,212895,269057,442997,405,885107,851040,948546,15413,608380,20200,365675,233421,662284,893332,193948,639783,263596,808932,31478,364895,146957,1029110,1045159,654181,391272,302276,207396,764173,287924,809099,32492,614146,27462,741498,638887,399894) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201872 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201872 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]