SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001840s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 918815 LIMIT 1 [ RunTime:0.000898s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 918815 [ RunTime:0.003983s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (141231,241691,52402,553064,110360,830582,179515,305944,560310,464756,70674,270406,300104,305491,98462,271942,39461,1035271,1018016,343770,981195,528008,501330,629273,297032,92551,873038,158195,269041,158205,421480,962680,957626,740865,821652,299764,1020460,993847,800972,420933,611945,764692,979192,210595,43046,1041822,421763,410691,982054,1028275,672022,453320,703940,789955,927430,46519,374201,288671,472354,623357) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 918815 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 918815 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]