SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478541 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478541 [ RunTime:0.001711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (119973,564439,756447,143691,931805,600118,108828,974088,481723,786441,128467,613319,957496,880399,682596,571191,393558,812762,670925,746643,308598,500523,231885,281169,16147,1001118,49940,490588,645670,560483,711812,718029,815454,331526,821352,248185,872416,51746,365495,176599,785564,678098,295648,502356,475103,301610,135454,843529,294908,35474,600868,458365,972221,102925,987340,56009,883257,700539,304658,422326) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000672s ]