SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405339 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405339 [ RunTime:0.002920s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1025840,271118,666418,235820,28476,142685,364318,487333,323676,1042619,584080,134983,197365,466987,439873,930195,612981,155502,493912,792520,87413,237458,688530,769621,710614,429429,693284,273727,450073,269000,811993,90215,986300,594701,935734,693226,293585,1007380,635598,928658,354205,455481,690586,594342,423791,680555,311233,181536,847602,66087,877401,48201,263106,39731,700211,950881,992421,834385,290075,8420) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405339 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405339 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]