SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001529s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 348541 LIMIT 1 [ RunTime:0.002114s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 348541 [ RunTime:0.002848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (912391,167979,611879,592490,546341,188,750729,500731,225468,941614,493383,3855,196839,643278,283397,197046,336688,230602,862306,567787,1037549,476056,912520,162454,231290,617621,344267,439987,449429,911381,131285,510624,764240,673328,530949,688791,594925,35182,724730,261564,211628,596416,785009,217290,615844,895739,830826,389573,764136,947424,815130,79107,1019160,222066,1029439,113717,312889,464528,284647,591828) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 348541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 348541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]