SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 46442 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 46442 [ RunTime:0.002420s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (372883,875161,213320,924076,353561,851982,703304,899711,240824,298580,756922,366113,481911,801519,325911,339695,390986,623695,43608,837034,403588,655318,949577,722522,1004952,543091,444665,751970,690152,656454,394723,758216,601649,5387,196666,824879,753791,154765,833151,78478,261449,1021677,904363,80406,812610,593232,825654,532530,993757,662393,73492,275344,993295,926689,323771,521607,505034,195508,696390,922469) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 46442 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 46442 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]