SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570104 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570104 [ RunTime:0.001593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (218578,121939,553355,850065,880078,483900,128602,118664,404470,544149,351160,991884,37476,650761,753221,142737,1012966,88411,1009668,393625,802484,689086,578428,34635,735036,411092,891132,1032634,806033,984576,275236,944819,73958,625701,119085,683983,232883,99474,666719,1031138,89846,369210,323123,420797,737317,222861,728780,563938,968598,449131,441410,162864,208483,765717,997014,103587,829760,1020529,920310,385162) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]