SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585252 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585252 [ RunTime:0.001860s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (245279,669214,411143,59928,695246,339384,839120,39744,567232,89215,214255,121902,989312,612165,430252,365987,886687,213342,76246,1000882,534012,491679,941942,764775,495583,819335,49578,857925,539110,607693,875081,19337,371151,873758,596672,944841,293674,624011,1886,343558,129188,349360,117262,146236,164899,536631,406709,407924,265373,1025139,678030,729318,912489,618074,244917,145653,284410,309987,203495,920375) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585252 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585252 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]