SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 358315 LIMIT 1 [ RunTime:0.000529s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 358315 [ RunTime:0.004457s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (179800,621549,101741,853667,953672,823507,930814,224960,261774,962947,413297,299020,558727,925406,232134,38484,6926,452190,243705,232192,516872,177520,101994,715004,581542,756176,313007,363844,521435,1027345,657100,479502,275960,121097,751093,863900,652715,135993,530414,788933,311355,518599,875339,938359,50725,757454,772843,838522,180217,645202,260135,50580,791464,450775,46067,209903,207050,797687,1026060,223088) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001623s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 358315 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000566s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 358315 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]