SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 35479 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 35479 [ RunTime:0.002071s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (253023,727524,877892,1022988,121131,522203,81200,748292,618754,681351,138330,106006,631864,277331,823083,273936,840436,620910,147375,651245,542527,524146,937718,830877,155975,214462,640931,274962,247530,399896,230738,171984,2619,875258,681400,385062,1040119,940062,890840,702023,907330,132206,191481,765689,568828,5470,464141,377276,427910,308424,523212,959141,321119,319680,341439,192282,778480,581574,573894,446030) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003700s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 35479 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 35479 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001244s ]