SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50880 LIMIT 1 [ RunTime:0.000282s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50880 [ RunTime:0.003327s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (741022,265684,525059,207778,132345,777078,1007249,203715,80304,124355,435454,223094,672887,11271,470858,933138,665748,655384,356007,1035628,897712,436440,999430,791385,726782,494387,967488,601478,1008903,929031,686635,567069,272644,737548,109639,1042686,645037,861078,106659,671306,712915,88796,405426,805823,59967,60624,1040124,257579,673630,704475,797527,975997,232237,611232,1022086,74926,480969,877034,342132,302741) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]