SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001629s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001020 LIMIT 1 [ RunTime:0.002206s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001020 [ RunTime:0.002028s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (104839,48146,1022666,635258,657467,571684,118476,943707,698714,586602,936234,62008,813528,789190,973318,61029,662980,625155,1045209,155095,219071,237800,495527,303465,438404,153616,748894,519880,737088,467608,907103,698776,917597,645864,908473,524519,490142,220473,673523,920913,924532,657922,395835,286092,141592,340049,601951,270426,185133,321636,376139,403314,289288,949809,162514,473710,329309,897434,41609,412161) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001020 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000737s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001020 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005238s ]