SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532308 LIMIT 1 [ RunTime:0.001313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532308 [ RunTime:0.002874s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (444631,131534,715543,853688,715248,58743,200211,356399,308200,419721,650427,512805,560960,526217,147625,202378,342171,133460,551709,695863,1044180,68843,318971,440552,665942,637740,626747,966323,778237,981599,229053,918078,862424,501983,548071,737152,162743,359613,844787,111527,676301,606835,895611,189685,579235,162218,475997,553218,696110,889248,855917,356676,622180,900475,797170,710318,630651,1010038,885902,420328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]