SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417013 LIMIT 1 [ RunTime:0.000441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417013 [ RunTime:0.002217s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (855554,249523,212664,509384,980888,476866,569131,327366,256062,199205,1020134,758573,797237,620089,438279,329015,209643,40897,53395,479240,1016730,248694,932143,658395,999707,981922,35068,530123,210538,545599,174248,245016,214664,737566,963072,730830,396729,796432,858826,562629,478440,635777,38272,283973,980021,851414,606688,178906,379699,69984,739738,862507,853087,434636,184258,677876,289003,614146,368214,993438) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005826s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000675s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002279s ]